EMT Practice Test

1. Question Content...

---

Question1: Northern Trail Outfitters (NTO) stores most of their customer data in Marketing Cloud. They do not mind their data being viewed in clear text within SFMC to users who have access, but they want to ensure the underlying database files are encrypted at rest in case the physical media is stolen.
Which encryption method should NTO use?

Question2: A developer initiated a batch delete of Contacts in Contact Builder due to an import error during implementation. There are over two million records that need to be deleted.
Which two factors should be considered when batch deleting large volumes of contacts?Choose 2 answers

Question3: A developer needs to write AMPscript to ensure the expiration date on a coupon is the last day of the month. What would produce the desired result?

Question4: From which business unit could the Contact Delete feature be used within an Enterprise 2.0 account?

Question5: A developer is implementing a custom profile center and using the LogUnsubEvent request. Which parameter is required for the event to be tied to the appropriate send?

Question6: Certification Aid wants to encrypt data stored in Marketing Cloud. It is fine if unencrypted fields are visible to Marketing Cloud and Salesforce users, but the underlying data should be encrypted at rest to prevent physical data theft. Which encryption method should be chosen? Choose 1.

Question7: A developer wants to use the Marketing Cloud SOAP API to retrieve which subscribers were sent a particular email. Which SOAP API object should be used?

Question8: Which SSJS library can be used in landing pages? Choose 1.

Question9: Northern Trail Outfitters (NTO) uses a numeric identifier for Subscriber Key. Customer data is stored in a data extension with the Subscriber Key set as a Primary Key.
Which step is required for NTO when creating relationships for this data extension in Data Designer'

Question10: Which SSJS library can be used in email messages? Choose 1.

Question11: A developer is making an API REST call to trigger an email send. An access token is used to authenticate the call.
How long are Marketing Cloud v1 access tokens valid?

Question12: A sendable data extension with a text field named 'Balance' contains the value S6.96 for a particular record. The following AMPscript statement is included in an email:
IF (Balance > 6.00) THEN
SET @Result = 'Balance is more than $6.00
ENDIF
Why would this IF statement yield unintended results?

Question13: A developer is building an integration with the Marketing Cloud API. Which configuration should be used for the API integration component in the associated Installed Package?

Question14: Certification Aid wants to import data from a CSV file into a Data Extension. The CSV file contains all relevant dat a. New records should be added to the Data Extension, and records which are not in the file should be removed from the Data Extension. Which import operation should be chosen for this? Choose 1.

Question15: Certification Aid wants to automate the import of zipped files into a Data Extension. The zip files are placed on the Marketing Cloud Enhanced FTP server every night. Which activity is needed before those files can be imported? Choose 1.

Question16: A developer needs to determine why a Query Activity in an Automation has failed.
Which three scenarios could have caused this? Choose 3 answers

Question17: How many month of data can a developer query from the tracking data views (_Sent, _Open, _Click)?

Question18: An email requires custom AMPscript to append the subscriber's zip code to a link in the email. A field name zipcode already exist in the sending data extension. Its important Marketing Cloud tracks subscribers who click on the link. Which two AMPscript functions should be used in the setup? Choose

Question19: A developer wants to trigger an SMS message to a subscriber using a form published on CloudPages. How should the SMS message be triggered once the subscriber submits the form?

Question20: A developer wants to include an AMPscript if/else statement in an email to satisfy the condition "if the subscriber's tier is not premier then display heading encouraging them to upgrade." The tier value has already been set as variable named @level. How should the developer write this AMPscript conditional statement?

Question21: NTO wants to trigger a receipt email via the SOAP API whenever a customer makes a purchase. Their developer wrote the call using the TriggerSendDefinition object and the Create method, but no emails have been sent during his initial testing. Which object and method should the developer use?

Question22: A developer wants to populate a data extension with the date of the most recent click for each subscriber. Which query would accomplish this?

Question23: A developer wants to implement a newsletter registration from on NTO's website. Prior to form submission, an email address provided by the visitor should be validated. Which option could be used to support this scenario?

Question24: A new record is appended to the Orders data extension each time a customer makes a purchase. Which SQL statement would select a unique list of subscribers who have made multiple purchases?

Question25: What can be created in Attribute Groups within Contact Builder? Choose 2.

Question26: A developer wants to aggregate monthly energy usage data over a four month period for each subscriber within an email. The monthly usage values are stored in variables for each month in the following way:
How should the developer use AMPscript to generate the total?

Question27: Certification Aid wants to trigger and email send in Marketing Cloud when a purchase is made on their website. Which API should be used for this? Choose 2.

Question28: Contact Builder can be used to create a relational model of an organization's data within Marketing Cloud. Which three factors should be taken into consideration when preparing data to be used in Contact Builder? Choose 3 answer

Question29: Where can the SSJS Core library be used? Choose 2.

Question30: A developer started a Contact Delete process that is now complete.
In which two places would the Contact Delete process remove data? Choose 2 answers

Question31: How can SSJS variables be referenced for content personalization? Choose 1.

Question32: Certification Aid wants to implement a custom profile center using SOAP API. Which SOAP API methods are relevant to achieve this? Choose 2.

Question33: A developer wants to create a CloudPage which is linked from an email. %%[SET @point = RequestParameter(x) SET @value = 5 IF Length(@point) > 1 THEN SET @value = 1 ELSEIF Length(@point)>2 THEN SET @value = 2 ELSEIF Length(@point) >3 THEN SET@value = 3 ELSEIF Length(@point) >4 THEN SET @value = 4 ENDIF]%% Which is the expected value of @value if x = 'Tacos'?

Question34: A developer uses an API to send data to a Marketing Cloud data extension once every five minutes using the REST API. They notice data does not always write to the data extension, leading to data loss.
Which three best practices are recommended to avoid this issue? Choose 3 answers

Question35: A developer wants to add an image to Content Builder via the API and retrieve the image's published URL. Which method should the developer use?

Question36: A developer is leveraging the SOAP API to dynamically display Profile and Preference Attributes in a custom profile center. Which method could be used to support the dynamic functionality?

Question37: A customer wants to export send data to their SFTP. Which two automations would accomplish this? Choose 2

Question38: Certification Aid wants to create a file drop automation with a filename pattern. An import file is placed daily on the Marketing Cloud Enhanced FTP server, and the file name always starts with the current month and day (e.g. OCT26). How should the filename pattern be defined? Choose 2.

Question39: A developer needs to push real-time updates of the company's product catalog to a data extension.
Which two API options are available? Choose 2 answers

Question40: A developer wants to build an email that dynamically populates the physical address of a company's locations using the variable address. The deployment goes to millions of subscribers and the developer wants the fastest possible performance.
Which AMPscript solution should be recommended?

Question41: NTO wants use Personally Identifiable Information (PII) data to personalize email communications, but does not want to store PII data in Marketing Cloud. Which feature could they use to personalize emails from an external data source?

Question42: When do synchronous REST API calls to Marketing Cloud time out? Choose 2.

Question43: NTO uses an external CRM which only exports encrypted files. NTO's marketing manager team wants to use some of the subscriber data found in the CRM for future marketing sends. Which three actions should be included in an automation given these requirements? Choose 3

Question44: A developer receives a request to integrate Marketing Cloud with a lead capture tool. The lead capture tool will call the Marketing Cloud API to create a data extension every time a new lead form is published. The created data extension's name should match the name of the form exactly.
Which API feature could the developer use to dynamically create these data extensions?

Question45: Certification Aid created following AMPscript code: %%[ SET @var1 = 10 SET @var2 = 20 SET @var3 = 30 ]%% How can the three variables be summed up to evaluate to 60? Choose 1.

Question46: When appending data to links via Web Analytics Connector, which parameter should be used to track subscriber behavior?

Question47: A developer wants to write a query to compile data originating from an HTML form so it can be exported in CSV format. However, the source data extension may contain line breaks within the Comments field, which makes it difficult to read and sort the resulting CSV.
Which SQL functions could be used to change each line break to a single space?

Question48: A developer created an email with AMPscript variable as the subject line. The subject line variable was recently updated, but when testing the email, the wrong subject line continues to appear in the inbox. The developer thinks another, outdated, subject line variable is declared within the email. Where could the outdated variable be located?

Question49: Which encryption methods are supported in file imports? Choose 2.